Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SQLTEXT_WITH_NEWLINES

This view is identical to the `V$SQLTEXT` view except that, to improve legibility, `V$SQLTEXT_WITH_NEWLINES` does not replace newlines and tabs in the SQL statement with spaces.

Column | Datatype | Description
--- | --- | ---
`ADDRESS` | `RAW(4 | 8)` | Used with `HASH_VALUE` to uniquely identify a cached cursor
`HASH_VALUE` | `NUMBER` | Used with `ADDRESS` to uniquely identify a cached cursor
`SQL_ID` | `VARCHAR2(13)` | SQL identifier of a cached cursor
`COMMAND_TYPE` | `NUMBER` | Code for the type of SQL statement (`SELECT`, `INSERT`, and so on)
`PIECE` | `NUMBER` | Number used to order the pieces of SQL text
`SQL_TEXT` | `VARCHAR2(64)` | A column containing one piece of the SQL text

See Also: "V$SQLTEXT"